<?php 
$this->E_D("DROP TABLE IF EXISTS `db_cms_work`;");
$this->E_C("CREATE TABLE `db_cms_work` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `catid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `modelid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `thumb` varchar(255) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `titleurl` varchar(255) NOT NULL DEFAULT '',
  `newstime` int(11) unsigned NOT NULL DEFAULT '0',
  `pagetitle` varchar(255) NOT NULL DEFAULT '',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `pubid` bigint(15) unsigned NOT NULL DEFAULT '0',
  `sort` int(11) unsigned NOT NULL DEFAULT '0',
  `userid` int(11) unsigned NOT NULL DEFAULT '0',
  `username` char(20) NOT NULL DEFAULT '',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0',
  `editortime` int(10) unsigned NOT NULL DEFAULT '0',
  `is_good` int(11) NOT NULL DEFAULT '0' COMMENT '推荐',
  `is_top` int(11) NOT NULL DEFAULT '0' COMMENT '置顶',
  `views` int(11) NOT NULL DEFAULT '0' COMMENT '点击总数',
  `goods` int(11) NOT NULL DEFAULT '0' COMMENT '点赞数',
  `favs` int(11) NOT NULL DEFAULT '0' COMMENT '收藏数',
  `comments` int(11) NOT NULL DEFAULT '0' COMMENT '评论数',
  `viewtemp` int(11) NOT NULL DEFAULT '0' COMMENT '单独内容模板',
  `description1` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`),
  KEY `sort` (`sort`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='table'");
$this->E_D("replace into `db_cms_work` values('1','127','64','研究','/upload/image/20211118/ae8c2fcbcff8bc583e545e24b86b0328.jpg','','','1637219932','','','','16372199323756','1','2','kenuo','1637292226','1637292226','0','0','0','0','0','0','0','科诺需要热爱创新、专业及有创见的研发人员。请加入我们的研发部门，把技能、经验及关怀注入产品中，为顾客排难解忧，把握发展机遇。');");
$this->E_D("replace into `db_cms_work` values('2','127','64','工程','/upload/image/20211118/10b4460990f0ce774b5657ec7bcc3b2f.jpg','','','1637220007','','','','16372200079733','2','2','kenuo','1637292331','1637292331','0','0','0','0','0','0','0','科诺需要专业、严谨的工程人员。请加入我们的工程团队，为顾客们建造最高效、安全的理想养殖场所，为他们带来可观投资回报。');");
$this->E_D("replace into `db_cms_work` values('3','127','64','物联网','/upload/image/20211118/a31f4a2957c64958ab8434b915d35826.jpg','','','1637220025','','','','16372200251666','3','2','kenuo','1637292334','1637292334','0','0','0','0','0','0','0','科诺需要精益求精、富有远见的人才。请加入我们的物联网团队，透过不断发展、改进、扩大农牧业方面的应用，同心合力联通各生产流程，与顾客一同迈向新世代智慧农牧。');");
$this->E_D("replace into `db_cms_work` values('4','127','64','制造','/upload/image/20211118/8eb9d60abc442e5c25eb4c695d120326.jpg','','','1637220042','','','','16372200424296','4','2','kenuo','1637292354','1637292354','0','0','0','0','0','0','0','科诺需要细心、一丝不苟的制造人员。请加入我们的制造团队，为顾客生产出高质高效，可信耐用的顶级产品。');");

 ?>